package com.aust.furniture.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.aust.furniture.vo.OwInfoCountForEchartsData;
import com.aust.furniture.entity.Owinfo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/*家具出入库的增删改查*/
public interface OwinfoMapper extends BaseMapper<Owinfo> {
    @Select("SELECT dname AS fname, SUM(count) AS count FROM owinfo where type = '入库' AND createtime >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH) GROUP BY dname ")
    List<OwInfoCountForEchartsData> getWarehousingData();
}
